On-Line Analytical Processing
نویسندگان
چکیده
DEFINITION On-line Analytical Processing (OLAP) describes an approach to decision support, which aims to extract knowledge from a data warehouse (see Data Warehouse definitional entry), or more specifically, from data marts (see Data Mart definitional entry). Its main idea is providing navigation through data to non-expert users, so that they are able to interactively generate ad-hoc queries without the intervention of IT professionals. This name was introduced in contrast to On-Line Transactional Processing (OLTP), so that it reflected the different requirements and characteristics between both kinds of uses. The concept falls in the area of business intelligence (see Business Intelligence definitional entry).
منابع مشابه
Design and Implementation of On-line Analytical Processing (olap) of Spatial Data Design and Implementation of On-line Analytical Pro- Cessing (olap) of Spatial Data
On-line analytical processing (OLAP) has gained its popularity in database industry. With a huge amount of data stored in spatial databases and the introduction of spatial components to many relational or object-relational databases, it is important to study the methods for spatial data warehousing and on-line analytical processing of spatial data. This thesis investigates methods for spatial O...
متن کاملOn-Line Analytical Processing with Conceptual Information Systems
A Conceptual Information System consists of a database together with conceptual hierarchies. The management system TOSCANA visualizes arbitrary combinations of conceptual hierarchies by nested line diagrams and allows an on-line interaction with a database to analyze data conceptually. The paper describes the conception of Conceptual Information Systems and discusses the use of their visualizat...
متن کاملChapter 14 CONCEPTUAL ON - LINE ANALYTICAL PROCESSING
A Conceptual Information System consists of a database together with conceptual hierarchies. The visualization of arbitrary combinations of conceptual hierarchies by nested line diagrams allows an on-line interaction with a database to analyze data conceptually. The chapter describes the conception of Conceptual Information Systems and discusses the use of their visualization techniques for On-...
متن کاملData Warehousing Applications: an Analytical Tool for Decision Support System
Data-driven decision support systems, such as data warehouses can serve the requirement of extraction of information from more than one subject area. Data warehouses standardize the data across the organization so as to have a single view of information. Data warehouses (DW) can provide the information required by the decision makers. The data warehouse supports an on-line analytical processing...
متن کاملData Warehousing, Data Mining, OLAP and OLTP Technologies Are Indispensable Elements to Support Decision-Making Process in Industrial World
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, new applications and the architecture of Data Warehousing and data mining. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the online transaction processing (OLTP) applications ...
متن کامل